579334852 by Unknown

Author:Unknown
Language: eng
Format: epub

Total sales June =

CALCULATE([Total sales],

FILTER(

ALL(Sales),

Sales[Month name] = "June"

)

)

I can define a variable and assign it with the value of ‘June’ as follows.

Notice all the red underlines in the DAX measure? This means that there is something wrong with the syntax. This is because DAX expects the function to be issued after defining variables in a measure:

Total sales June =

VAR MonthVariable = "June"

Return

CALCULATE([Total Sales],

FILTER(

ALL(Sales),

Sales[Month Name] = MonthVariable

)

)

This will return with the same result as before:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.